Tabela ActionLog

Definicja tabeli ActionLog

Name

ActionLog

Code

ActionLog

Comment

 


Lista kolumn tabeli ActionLog

Name

Code

ActionCodeID

ActionCodeID

ActionTypeID

ActionTypeID

ActionDT

ActionDT

ClientIP

ClientIP

Login

Login

FirstName

FirstName

LastName

LastName

PersonID

PersonID

MethodName

MethodName

PatientID

PatientID

EpisodeID

EpisodeID

EventID

EventID

VisitID

VisitID

Comments

Comments

RecordValueID

RecordValueID

RecordValue

RecordValue

SystemID

SystemID

SystemName

SystemName


Kolumna ActionCodeID tabeli ActionLog

Definicja kolumny ActionCodeID tabeli ActionLog

Name

ActionCodeID

Code

ActionCodeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ActionTypeID tabeli ActionLog

Definicja kolumny ActionTypeID tabeli ActionLog

Name

ActionTypeID

Code

ActionTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ActionDT tabeli ActionLog

Definicja kolumny ActionDT tabeli ActionLog

Name

ActionDT

Code

ActionDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna ClientIP tabeli ActionLog

Definicja kolumny ClientIP tabeli ActionLog

Name

ClientIP

Code

ClientIP

Data Type

VARCHAR2(15)

Mandatory

No

Comment

 


Kolumna Login tabeli ActionLog

Definicja kolumny Login tabeli ActionLog

Name

Login

Code

Login

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna FirstName tabeli ActionLog

Definicja kolumny FirstName tabeli ActionLog

Name

FirstName

Code

FirstName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

PL: Imie
EN: First Name
DE: der Name


Kolumna LastName tabeli ActionLog

Definicja kolumny LastName tabeli ActionLog

Name

LastName

Code

LastName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

PL: Nazwisko
EN: Last name
DE: der Nachname


Kolumna PersonID tabeli ActionLog

Definicja kolumny PersonID tabeli ActionLog

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MethodName tabeli ActionLog

Definicja kolumny MethodName tabeli ActionLog

Name

MethodName

Code

MethodName

Data Type

VARCHAR2(150)

Mandatory

No

Comment

 


Kolumna PatientID tabeli ActionLog

Definicja kolumny PatientID tabeli ActionLog

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeID tabeli ActionLog

Definicja kolumny EpisodeID tabeli ActionLog

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EventID tabeli ActionLog

Definicja kolumny EventID tabeli ActionLog

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VisitID tabeli ActionLog

Definicja kolumny VisitID tabeli ActionLog

Name

VisitID

Code

VisitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Comments tabeli ActionLog

Definicja kolumny Comments tabeli ActionLog

Name

Comments

Code

Comments

Data Type

VARCHAR2(1020)

Mandatory

No

Comment

 


Kolumna RecordValueID tabeli ActionLog

Definicja kolumny RecordValueID tabeli ActionLog

Name

RecordValueID

Code

RecordValueID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RecordValue tabeli ActionLog

Definicja kolumny RecordValue tabeli ActionLog

Name

RecordValue

Code

RecordValue

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna SystemID tabeli ActionLog

Definicja kolumny SystemID tabeli ActionLog

Name

SystemID

Code

SystemID

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator systemu


Kolumna SystemName tabeli ActionLog

Definicja kolumny SystemName tabeli ActionLog

Name

SystemName

Code

SystemName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

nazwa systemu